Total Complexity | 2 |
Total Lines | 12 |
Duplicated Lines | 0 % |
Changes | 0 |
1 | import {MigrationInterface, QueryRunner} from "typeorm"; |
||
2 | |||
3 | export class MealTicketRemoval1608728416097 implements MigrationInterface { |
||
4 | name = 'MealTicketRemoval1608728416097' |
||
5 | |||
6 | public async up(queryRunner: QueryRunner): Promise<void> { |
||
7 | await queryRunner.query(`CREATE TABLE "meal_ticket_removal" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "date" TIMESTAMP NOT NULL, "comment" character varying NOT NULL, "userId" uuid NOT NULL, CONSTRAINT "PK_16f717305130d7b2765ed2a467c" PRIMARY KEY ("id"))`); |
||
8 | await queryRunner.query(`ALTER TABLE "meal_ticket_removal" ADD CONSTRAINT "FK_a27eae7bbdbcbe9d67b5f77dd76" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); |
||
9 | } |
||
10 | |||
11 | public async down(queryRunner: QueryRunner): Promise<void> { |
||
12 | await queryRunner.query(`ALTER TABLE "meal_ticket_removal" DROP CONSTRAINT "FK_a27eae7bbdbcbe9d67b5f77dd76"`); |
||
13 | await queryRunner.query(`DROP TABLE "meal_ticket_removal"`); |
||
14 | } |
||
17 |